inherited FormComissao: TFormComissao
  Tag = 5
  Left = 484
  Top = 259
  Caption = 'Comiss'#245'es geradas'
  ClientHeight = 422
  ClientWidth = 742
  OldCreateOrder = True
  PixelsPerInch = 96
  TextHeight = 13
  inherited Splitter1: TSplitter
    Height = 353
  end
  inherited pnlSelec: TPanel
    Height = 353
    inherited Splitter3: TSplitter
      Top = 121
    end
    inherited pnlBusca: TGroupBox
      Height = 120
      inherited lblCriterio: TLabel
        Top = 56
        Width = 95
        Caption = 'Descri'#231#227'o do Grupo'
      end
      object Label4: TLabel [1]
        Left = 8
        Top = 16
        Width = 41
        Height = 13
        Caption = 'N'#186' inicial'
      end
      object Label5: TLabel [2]
        Left = 68
        Top = 16
        Width = 34
        Height = 13
        Caption = 'N'#186' final'
      end
      object Label10: TLabel [3]
        Left = 136
        Top = 16
        Width = 38
        Height = 13
        Caption = 'Per'#237'odo'
      end
      inherited CRITERIO: TMaskEdit
        Top = 72
      end
      object GRUPOINI: TMaskEdit
        Tag = -1
        Left = 8
        Top = 32
        Width = 49
        Height = 19
        CharCase = ecUpperCase
        Ctl3D = False
        ParentCtl3D = False
        TabOrder = 1
        OnChange = CRITERIOChange
        OnExit = CRITERIOExit
      end
      object GRUPOFIM: TMaskEdit
        Tag = 1
        Left = 68
        Top = 32
        Width = 49
        Height = 19
        CharCase = ecUpperCase
        Ctl3D = False
        ParentCtl3D = False
        TabOrder = 2
        OnChange = CRITERIOChange
        OnExit = CRITERIOExit
      end
      object PERIODO: TMaskEdit
        Left = 136
        Top = 32
        Width = 57
        Height = 19
        CharCase = ecUpperCase
        Ctl3D = False
        ParentCtl3D = False
        TabOrder = 3
        OnChange = CRITERIOChange
        OnExit = CRITERIOExit
      end
    end
    inherited dbgRelacao: TSMDBGrid
      Top = 124
      Height = 228
      Columns = <
        item
          Expanded = False
          FieldName = 'GRUPO_CODIGO'
          Width = 44
          Visible = True
          FooterValue = 'Qtd:'
          FooterType = ftCustom
        end
        item
          Expanded = False
          FieldName = 'GRUPO_DESCRICAO'
          Width = 124
          Visible = True
          FooterType = ftCount
        end>
    end
  end
  inherited Panel1: TPanel
    Width = 530
    Height = 353
    inherited Splitter2: TSplitter
      Top = 41
      Width = 528
      Align = alTop
    end
    inherited PageControl1: TPageControl
      Top = 44
      Width = 528
      Height = 308
      ActivePage = TabSheet4
      Align = alClient
      object tsPostos: TTabSheet
        Caption = 'Postos'
        object SMDBGrid1: TSMDBGrid
          Left = 0
          Top = 0
          Width = 520
          Height = 280
          Align = alClient
          Color = clWhite
          Ctl3D = False
          DataSource = dsFranGrupo
          Font.Charset = DEFAULT_CHARSET
          Font.Color = clWindowText
          Font.Height = -11
          Font.Name = 'MS Sans Serif'
          Font.Style = []
          Options = [dgTitles, dgIndicator, dgColumnResize, dgColLines, dgTabs, dgRowSelect, dgAlwaysShowSelection, dgConfirmDelete, dgCancelOnExit]
          ParentCtl3D = False
          ParentFont = False
          ReadOnly = True
          TabOrder = 0
          TitleFont.Charset = DEFAULT_CHARSET
          TitleFont.Color = clBlack
          TitleFont.Height = -11
          TitleFont.Name = 'MS Sans Serif'
          TitleFont.Style = [fsBold]
          Flat = True
          BandsFont.Charset = DEFAULT_CHARSET
          BandsFont.Color = clWindowText
          BandsFont.Height = -11
          BandsFont.Name = 'MS Sans Serif'
          BandsFont.Style = []
          Groupings = <>
          GridStyle.Style = gsSoftBrick
          GridStyle.OddColor = 14675694
          GridStyle.EvenColor = 13493476
          TitleHeight.PixelCount = 24
          FooterColor = clBtnFace
          ExOptions = [eoBooleanAsCheckBox, eoDisableDelete, eoDisableInsert, eoDrawGraphicField, eoENTERlikeTAB, eoKeepSelection, eoRowNumber, eoRowSizing, eoSelectedTitle, eoShowGlyphs, eoShowLookup, eoShowRecNo, eoStandardPopup, eoBLOBEditor]
          RegistryKey = 'Software\Scalabium'
          RegistrySection = 'SMDBGrid'
          WidthOfIndicator = 11
          DefaultRowHeight = 16
          ScrollBars = ssHorizontal
          ColCount = 42
          RowCount = 2
          Columns = <
            item
              Expanded = False
              FieldName = 'FRANQUIA_CODIGO'
              Width = 50
              Visible = True
              FooterType = ftCustom
            end
            item
              Expanded = False
              FieldName = 'Descricao'
              Width = 186
              Visible = True
              FooterType = ftCustom
            end
            item
              Expanded = False
              FieldName = 'CLARO10'
              Width = 48
              Visible = True
              FooterType = ftCustom
            end
            item
              Expanded = False
              FieldName = 'CLARO15'
              Width = 49
              Visible = True
              FooterType = ftCustom
            end
            item
              Expanded = False
              FieldName = 'CLARO20'
              Width = 50
              Visible = True
              FooterType = ftCustom
            end
            item
              Expanded = False
              FieldName = 'CLARO30'
              Width = 51
              Visible = True
              FooterType = ftCustom
            end
            item
              Expanded = False
              FieldName = 'CLARO50'
              Width = 51
              Visible = True
              FooterType = ftCustom
            end
            item
              Expanded = False
              FieldName = 'CLARO'
              Width = 37
              Visible = True
              FooterType = ftCustom
            end
            item
              Expanded = False
              FieldName = 'OI05'
              Width = 37
              Visible = True
              FooterType = ftCustom
            end
            item
              Expanded = False
              FieldName = 'OI10'
              Width = 37
              Visible = True
              FooterType = ftCustom
            end
            item
              Expanded = False
              FieldName = 'OI15'
              Width = 38
              Visible = True
              FooterType = ftCustom
            end
            item
              Expanded = False
              FieldName = 'OI20'
              Width = 38
              Visible = True
              FooterType = ftCustom
            end
            item
              Expanded = False
              FieldName = 'OI25'
              Width = 43
              Visible = True
              FooterType = ftCustom
            end
            item
              Expanded = False
              FieldName = 'OI50'
              Width = 42
              Visible = True
              FooterType = ftCustom
            end
            item
              Expanded = False
              FieldName = 'OI'
              Width = 28
              Visible = True
              FooterType = ftCustom
            end
            item
              Expanded = False
              FieldName = 'TIM15'
              Width = 49
              Visible = True
              FooterType = ftCustom
            end
            item
              Expanded = False
              FieldName = 'TIM20'
              Width = 47
              Visible = True
              FooterType = ftCustom
            end
            item
              Expanded = False
              FieldName = 'TIM25'
              Width = 47
              Visible = True
              FooterType = ftCustom
            end
            item
              Expanded = False
              FieldName = 'TIM35'
              Width = 45
              Visible = True
              FooterType = ftCustom
            end
            item
              Expanded = False
              FieldName = 'TIM50'
              Width = 45
              Visible = True
              FooterType = ftCustom
            end
            item
              Expanded = False
              FieldName = 'TIM100'
              Width = 50
              Visible = True
              FooterType = ftCustom
            end
            item
              Expanded = False
              FieldName = 'TIM'
              Width = 38
              Visible = True
              FooterType = ftCustom
            end
            item
              Expanded = False
              FieldName = 'EMBLDR10'
              Width = 48
              Visible = True
              FooterType = ftCustom
            end
            item
              Expanded = False
              FieldName = 'EMBLDR20'
              Width = 51
              Visible = True
              FooterType = ftCustom
            end
            item
              Expanded = False
              FieldName = 'EMBLDR15'
              Visible = True
              FooterType = ftCustom
            end
            item
              Expanded = False
              FieldName = 'EMBLDR30'
              Visible = True
              FooterType = ftCustom
            end
            item
              Expanded = False
              FieldName = 'EMBLDR45'
              Visible = True
              FooterType = ftCustom
            end
            item
              Expanded = False
              FieldName = 'EMBLDR90'
              Visible = True
              FooterType = ftCustom
            end
            item
              Expanded = False
              FieldName = 'EMBLDR'
              Visible = True
              FooterType = ftCustom
            end
            item
              Expanded = False
              FieldName = 'EMBLIVRE07'
              Visible = True
              FooterType = ftCustom
            end
            item
              Expanded = False
              FieldName = 'EMBLIVRE15'
              Visible = True
              FooterType = ftCustom
            end
            item
              Expanded = False
              FieldName = 'EMBLIVRE21'
              Visible = True
              FooterType = ftCustom
            end
            item
              Expanded = False
              FieldName = 'EMBLIVRE50'
              Visible = True
              FooterType = ftCustom
            end
            item
              Expanded = False
              FieldName = 'EMBLIVRE55'
              Visible = True
              FooterType = ftCustom
            end
            item
              Expanded = False
              FieldName = 'EMBLIVRE70'
              Visible = True
              FooterType = ftCustom
            end
            item
              Expanded = False
              FieldName = 'EMBLIVRE75'
              Visible = True
              FooterType = ftCustom
            end
            item
              Expanded = False
              FieldName = 'EMBLIVRE90'
              Visible = True
              FooterType = ftCustom
            end
            item
              Expanded = False
              FieldName = 'EMBLIVRE'
              Visible = True
              FooterType = ftCustom
            end
            item
              Expanded = False
              FieldName = 'VALEGAS'
              Visible = True
              FooterType = ftCustom
            end
            item
              Expanded = False
              FieldName = 'GUIAS'
              Visible = True
              FooterType = ftCustom
            end
            item
              Expanded = False
              FieldName = 'MEDIA'
              Visible = True
              FooterType = ftCustom
            end>
        end
      end
      object TabSheet4: TTabSheet
        Caption = 'Dados de pagamentos'
        ImageIndex = 3
        object GroupBox1: TGroupBox
          Left = 0
          Top = 0
          Width = 217
          Height = 280
          Align = alLeft
          Caption = 'Dados Banc'#225'rios'
          TabOrder = 0
          object Label15: TLabel
            Left = 8
            Top = 231
            Width = 43
            Height = 13
            Caption = 'Garantia:'
          end
          object DBText15: TDBText
            Left = 52
            Top = 231
            Width = 76
            Height = 13
            DataField = 'COMISSAO_GARANTIA'
            DataSource = dsDados
            Font.Charset = DEFAULT_CHARSET
            Font.Color = clBlack
            Font.Height = -11
            Font.Name = 'MS Sans Serif'
            Font.Style = [fsBold]
            ParentFont = False
          end
          object DBText5: TDBText
            Left = 48
            Top = 89
            Width = 50
            Height = 13
            AutoSize = True
            DataField = 'COMISSAO_ISS'
            DataSource = dsDados
            Font.Charset = DEFAULT_CHARSET
            Font.Color = clBlack
            Font.Height = -11
            Font.Name = 'MS Sans Serif'
            Font.Style = [fsBold]
            ParentFont = False
          end
          object Label7: TLabel
            Left = 8
            Top = 89
            Width = 37
            Height = 13
            Caption = 'ISS (%):'
          end
          object Label8: TLabel
            Left = 8
            Top = 36
            Width = 92
            Height = 13
            Caption = 'Comiss'#227'o Claro (%):'
          end
          object DBText6: TDBText
            Left = 104
            Top = 36
            Width = 50
            Height = 13
            AutoSize = True
            DataField = 'GRUPO_CREDIGI'
            DataSource = dsDados
            Font.Charset = DEFAULT_CHARSET
            Font.Color = clBlack
            Font.Height = -11
            Font.Name = 'MS Sans Serif'
            Font.Style = [fsBold]
            ParentFont = False
          end
          object DBText7: TDBText
            Left = 88
            Top = 20
            Width = 50
            Height = 13
            AutoSize = True
            DataField = 'Guias'
            DataSource = dsDados
            Font.Charset = DEFAULT_CHARSET
            Font.Color = clBlack
            Font.Height = -11
            Font.Name = 'MS Sans Serif'
            Font.Style = [fsBold]
            ParentFont = False
          end
          object Label16: TLabel
            Left = 8
            Top = 19
            Width = 76
            Height = 13
            Caption = 'Comiss'#227'o guias:'
          end
          object Label11: TLabel
            Left = 8
            Top = 140
            Width = 34
            Height = 13
            Caption = 'Banco:'
          end
          object DBText11: TDBText
            Left = 42
            Top = 140
            Width = 57
            Height = 13
            AutoSize = True
            DataField = 'Banco'
            DataSource = dsDados
            Font.Charset = DEFAULT_CHARSET
            Font.Color = clBlack
            Font.Height = -11
            Font.Name = 'MS Sans Serif'
            Font.Style = [fsBold]
            ParentFont = False
          end
          object Label14: TLabel
            Left = 8
            Top = 158
            Width = 32
            Height = 13
            Caption = 'Titular:'
          end
          object DBText14: TDBText
            Left = 40
            Top = 158
            Width = 57
            Height = 13
            AutoSize = True
            DataField = 'COMISSAO_TITULAR'
            DataSource = dsDados
            Font.Charset = DEFAULT_CHARSET
            Font.Color = clBlack
            Font.Height = -11
            Font.Name = 'MS Sans Serif'
            Font.Style = [fsBold]
            ParentFont = False
          end
          object Label12: TLabel
            Left = 8
            Top = 175
            Width = 42
            Height = 13
            Caption = 'Ag'#234'ncia:'
          end
          object DBText12: TDBText
            Left = 50
            Top = 175
            Width = 57
            Height = 13
            AutoSize = True
            DataField = 'COMISSAO_AGENCIA'
            DataSource = dsDados
            Font.Charset = DEFAULT_CHARSET
            Font.Color = clBlack
            Font.Height = -11
            Font.Name = 'MS Sans Serif'
            Font.Style = [fsBold]
            ParentFont = False
          end
          object DBText13: TDBText
            Left = 41
            Top = 194
            Width = 79
            Height = 13
            DataField = 'COMISSAO_CONTA'
            DataSource = dsDados
            Font.Charset = DEFAULT_CHARSET
            Font.Color = clBlack
            Font.Height = -11
            Font.Name = 'MS Sans Serif'
            Font.Style = [fsBold]
            ParentFont = False
          end
          object Label13: TLabel
            Left = 8
            Top = 194
            Width = 31
            Height = 13
            Caption = 'Conta:'
          end
          object Label6: TLabel
            Left = 8
            Top = 212
            Width = 54
            Height = 13
            Caption = 'Tipo conta:'
          end
          object DBText4: TDBText
            Left = 63
            Top = 212
            Width = 79
            Height = 13
            DataField = 'GRUPO_TIPOCONTA'
            DataSource = dsDados
            Font.Charset = DEFAULT_CHARSET
            Font.Color = clBlack
            Font.Height = -11
            Font.Name = 'MS Sans Serif'
            Font.Style = [fsBold]
            ParentFont = False
          end
          object Label2: TLabel
            Left = 8
            Top = 53
            Width = 78
            Height = 13
            Caption = 'Comiss'#227'o Oi (%):'
          end
          object DBText2: TDBText
            Left = 88
            Top = 53
            Width = 50
            Height = 13
            AutoSize = True
            DataField = 'GRUPO_OI'
            DataSource = dsDados
            Font.Charset = DEFAULT_CHARSET
            Font.Color = clBlack
            Font.Height = -11
            Font.Name = 'MS Sans Serif'
            Font.Style = [fsBold]
            ParentFont = False
          end
          object Label3: TLabel
            Left = 8
            Top = 70
            Width = 85
            Height = 13
            Caption = 'Comiss'#227'o Tim (%):'
          end
          object DBText3: TDBText
            Left = 96
            Top = 70
            Width = 50
            Height = 13
            AutoSize = True
            DataField = 'GRUPO_TIM'
            DataSource = dsDados
            Font.Charset = DEFAULT_CHARSET
            Font.Color = clBlack
            Font.Height = -11
            Font.Name = 'MS Sans Serif'
            Font.Style = [fsBold]
            ParentFont = False
          end
          object DBCheckBox2: TDBCheckBox
            Left = 8
            Top = 120
            Width = 169
            Height = 17
            Caption = 'N'#227'o depositar'
            Ctl3D = False
            DataField = 'COMISSAO_NDEPOSITAR'
            DataSource = dsDados
            ParentCtl3D = False
            ReadOnly = True
            TabOrder = 0
            ValueChecked = 'S'
            ValueUnchecked = 'N'
          end
          object DBCheckBox1: TDBCheckBox
            Left = 8
            Top = 104
            Width = 169
            Height = 17
            Caption = 'N'#227'o depositar'
            Ctl3D = False
            DataField = 'COMISSAO_JUNTAR'
            DataSource = dsDados
            ParentCtl3D = False
            ReadOnly = True
            TabOrder = 1
            ValueChecked = 'S'
            ValueUnchecked = 'N'
          end
        end
        object GroupBox4: TGroupBox
          Left = 217
          Top = 0
          Width = 303
          Height = 280
          Align = alClient
          Caption = 'Ajustes'
          TabOrder = 1
          object dbgAjustes: TSMDBGrid
            Left = 2
            Top = 15
            Width = 299
            Height = 263
            Align = alClient
            Color = clWhite
            Ctl3D = False
            DataSource = dsAjusteGrupo
            Font.Charset = DEFAULT_CHARSET
            Font.Color = clWindowText
            Font.Height = -11
            Font.Name = 'MS Sans Serif'
            Font.Style = []
            Options = [dgTitles, dgIndicator, dgColumnResize, dgColLines, dgTabs, dgRowSelect, dgAlwaysShowSelection, dgConfirmDelete, dgCancelOnExit]
            ParentCtl3D = False
            ParentFont = False
            ReadOnly = True
            TabOrder = 0
            TitleFont.Charset = DEFAULT_CHARSET
            TitleFont.Color = clBlack
            TitleFont.Height = -11
            TitleFont.Name = 'MS Sans Serif'
            TitleFont.Style = [fsBold]
            Flat = True
            BandsFont.Charset = DEFAULT_CHARSET
            BandsFont.Color = clWindowText
            BandsFont.Height = -11
            BandsFont.Name = 'MS Sans Serif'
            BandsFont.Style = []
            Groupings = <>
            GridStyle.Style = gsSoftBrick
            GridStyle.OddColor = 14675694
            GridStyle.EvenColor = 13493476
            TitleHeight.PixelCount = 24
            FooterColor = clBtnFace
            ExOptions = [eoBooleanAsCheckBox, eoDisableDelete, eoDisableInsert, eoDrawGraphicField, eoENTERlikeTAB, eoKeepSelection, eoRowNumber, eoRowSizing, eoSelectedTitle, eoShowFooter, eoShowGlyphs, eoShowLookup, eoShowRecNo, eoStandardPopup, eoBLOBEditor]
            RegistryKey = 'Software\Scalabium'
            RegistrySection = 'SMDBGrid'
            WidthOfIndicator = 11
            DefaultRowHeight = 16
            ScrollBars = ssHorizontal
            ColCount = 3
            RowCount = 2
            Columns = <
              item
                Expanded = False
                FieldName = 'AJUSTEGRUPO_DESCRICAO'
                Width = 131
                Visible = True
                FooterValue = 'Total'
                FooterType = ftCustom
              end
              item
                Expanded = False
                FieldName = 'AJUSTECOMISSAO_VALOR'
                Width = 58
                Visible = True
                FooterType = ftSum
              end>
          end
        end
      end
      object TabSheet3: TTabSheet
        Caption = 'Observa'#231#245'es'
        ImageIndex = 2
        object DBRichEdit1: TDBRichEdit
          Left = 0
          Top = 0
          Width = 520
          Height = 280
          Align = alClient
          BorderStyle = bsNone
          DataField = 'COMISSAO_OBS'
          DataSource = dsDados
          ReadOnly = True
          TabOrder = 0
        end
      end
    end
    object Panel2: TPanel
      Left = 1
      Top = 1
      Width = 528
      Height = 40
      Align = alTop
      BevelOuter = bvNone
      TabOrder = 1
      object DBText9: TDBText
        Left = 34
        Top = 22
        Width = 50
        Height = 13
        AutoSize = True
        DataField = 'GRUPO_ATT'
        DataSource = dsDados
        Font.Charset = DEFAULT_CHARSET
        Font.Color = clBlack
        Font.Height = -11
        Font.Name = 'MS Sans Serif'
        Font.Style = [fsBold]
        ParentFont = False
      end
      object Label9: TLabel
        Left = 7
        Top = 22
        Width = 19
        Height = 13
        Caption = 'Att.:'
      end
      object Label1: TLabel
        Left = 7
        Top = 5
        Width = 51
        Height = 13
        Caption = 'Descri'#231#227'o:'
      end
      object DBText1: TDBText
        Left = 63
        Top = 5
        Width = 50
        Height = 13
        AutoSize = True
        DataField = 'GRUPO_DESCRICAO'
        DataSource = dsDados
        Font.Charset = DEFAULT_CHARSET
        Font.Color = clBlack
        Font.Height = -11
        Font.Name = 'MS Sans Serif'
        Font.Style = [fsBold]
        ParentFont = False
      end
    end
  end
  inherited ToolBar1: TToolBar
    Width = 742
  end
  inherited pnCabecalho: TPanel
    Width = 742
    inherited Image1: TImage
      Width = 742
    end
  end
  inherited dsDados: TDataSource
    Left = 320
    Top = 192
  end
  inherited qryDados: TADOQuery
    CursorType = ctStatic
    BeforeOpen = qryDadosBeforeOpen
    BeforeClose = qryDadosBeforeClose
    AfterScroll = qryDadosAfterScroll
    Parameters = <
      item
        Name = 'CRITERIO'
        DataType = ftString
        NumericScale = 255
        Precision = 255
        Size = 50
        Value = '%'
      end
      item
        Name = 'GRUPOINI'
        Attributes = [paSigned]
        DataType = ftInteger
        Precision = 10
        Size = 4
        Value = -100000
      end
      item
        Name = 'GRUPOFIM'
        Attributes = [paSigned]
        DataType = ftInteger
        Precision = 10
        Size = 4
        Value = 100000
      end
      item
        Name = 'PERIODO'
        DataType = ftString
        NumericScale = 255
        Precision = 255
        Size = 5
        Value = 'MAR06'
      end>
    SQL.Strings = (
      'SELECT * FROM COMISSAO'
      'WHERE (GRUPO_DESCRICAO LIKE :CRITERIO)'
      'AND (GRUPO_CODIGO BETWEEN :GRUPOINI AND :GRUPOFIM)'
      'AND (COMISSAO_PERIODO LIKE :PERIODO)'
      'ORDER BY GRUPO_CODIGO')
    Left = 320
    Top = 176
    object qryDadosGuias: TStringField
      FieldKind = fkLookup
      FieldName = 'Guias'
      LookupDataSet = qryCalculo
      LookupKeyFields = 'CALGUIA_CODIGO'
      LookupResultField = 'CALGUIA_DESCRICAO'
      KeyFields = 'CALGUIA_CODIGO'
      LookupCache = True
      Size = 50
      Lookup = True
    end
    object qryDadosGRUPO_ATT: TStringField
      FieldName = 'GRUPO_ATT'
      Size = 30
    end
    object qryDadosBanco: TStringField
      FieldKind = fkLookup
      FieldName = 'Banco'
      LookupDataSet = qryBanco
      LookupKeyFields = 'CODIGO'
      LookupResultField = 'NOME'
      KeyFields = 'COMISSAO_BANCO'
      LookupCache = True
      Size = 50
      Lookup = True
    end
    object qryDadosGRUPO_CODIGO: TIntegerField
      DisplayLabel = 'N'#186
      FieldName = 'GRUPO_CODIGO'
    end
    object qryDadosGRUPO_TIPOCONTA: TStringField
      FieldName = 'GRUPO_TIPOCONTA'
      Size = 15
    end
    object qryDadosGRUPO_OI: TBCDField
      FieldName = 'GRUPO_OI'
      currency = True
      Precision = 19
    end
    object qryDadosGRUPO_TIM: TBCDField
      FieldName = 'GRUPO_TIM'
      currency = True
      Precision = 19
    end
    object qryDadosCOMISSAO_PERIODO: TStringField
      FieldName = 'COMISSAO_PERIODO'
      FixedChar = True
      Size = 5
    end
    object qryDadosCOMISSAO_JUNTAR: TStringField
      FieldName = 'COMISSAO_JUNTAR'
      FixedChar = True
      Size = 1
    end
    object qryDadosCOMISSAO_BANCO: TSmallintField
      FieldName = 'COMISSAO_BANCO'
    end
    object qryDadosCOMISSAO_AGENCIA: TStringField
      FieldName = 'COMISSAO_AGENCIA'
      FixedChar = True
      Size = 8
    end
    object qryDadosCOMISSAO_TITULAR: TStringField
      FieldName = 'COMISSAO_TITULAR'
      Size = 50
    end
    object qryDadosCOMISSAO_GARANTIA: TBCDField
      FieldName = 'COMISSAO_GARANTIA'
      Precision = 19
    end
    object qryDadosCOMISSAO_OBS: TMemoField
      FieldName = 'COMISSAO_OBS'
      BlobType = ftMemo
    end
    object qryDadosCOMISSAO_AJUSTES: TBCDField
      FieldName = 'COMISSAO_AJUSTES'
      Precision = 19
    end
    object qryDadosCOMISSAO_CONTA: TStringField
      FieldName = 'COMISSAO_CONTA'
      Size = 15
    end
    object qryDadosCOMISSAO_NDEPOSITAR: TStringField
      FieldName = 'COMISSAO_NDEPOSITAR'
      FixedChar = True
      Size = 1
    end
    object qryDadosGRUPO_CREDIGI: TBCDField
      FieldName = 'GRUPO_CREDIGI'
      Precision = 19
    end
    object qryDadosCALGUIA_CODIGO: TIntegerField
      FieldName = 'CALGUIA_CODIGO'
    end
    object qryDadosGRUPO_DESCRICAO: TStringField
      DisplayLabel = 'Descri'#231#227'o'
      FieldName = 'GRUPO_DESCRICAO'
      Size = 50
    end
    object qryDadosCOMISSAO_ISS: TBCDField
      FieldName = 'COMISSAO_ISS'
      Precision = 19
    end
  end
  inherited actAcoes: TActionList
    Left = 172
    Top = 317
  end
  inherited imlIcones: TImageList
    Left = 140
    Top = 317
  end
  inherited qryGeral: TADOQuery
    Left = 376
    Top = 176
  end
  object qryCalculo: TADOQuery
    Connection = FormPrincipal.cnRegente
    CursorType = ctStatic
    Parameters = <>
    SQL.Strings = (
      'SELECT * FROM CALGUIA')
    Left = 320
    Top = 224
    object qryCalculoCALGUIA_CODIGO: TAutoIncField
      FieldName = 'CALGUIA_CODIGO'
      ReadOnly = True
    end
    object qryCalculoCALGUIA_DESCRICAO: TStringField
      FieldName = 'CALGUIA_DESCRICAO'
      Size = 50
    end
  end
  object qryFranGrupo: TADOQuery
    Connection = FormPrincipal.cnRegente
    CursorType = ctStatic
    AfterInsert = qryFranGrupoAfterInsert
    DataSource = dsDados
    Parameters = <
      item
        Name = 'GRUPO_CODIGO'
        Attributes = [paSigned]
        DataType = ftInteger
        Precision = 10
        Size = 4
        Value = Null
      end
      item
        Name = 'COMISSAO_PERIODO'
        DataType = ftString
        NumericScale = 255
        Precision = 255
        Size = 5
        Value = Null
      end>
    SQL.Strings = (
      'SELECT * FROM FRANCOMISSAO'
      'WHERE (GRUPO_CODIGO=:GRUPO_CODIGO)'
      'AND (COMISSAO_PERIODO=:COMISSAO_PERIODO)')
    Left = 376
    Top = 208
    object qryFranGrupoGRUPO_CODIGO: TIntegerField
      FieldName = 'GRUPO_CODIGO'
    end
    object qryFranGrupoFRANQUIA_CODIGO: TIntegerField
      DisplayLabel = 'N'#250'mero'
      FieldName = 'FRANQUIA_CODIGO'
    end
    object qryFranGrupoDescricao: TStringField
      DisplayLabel = 'Descri'#231#227'o'
      FieldKind = fkLookup
      FieldName = 'Descricao'
      LookupDataSet = qryPostos
      LookupKeyFields = 'CODIGO'
      LookupResultField = 'NOME_FANTASIA'
      KeyFields = 'FRANQUIA_CODIGO'
      LookupCache = True
      Size = 50
      Lookup = True
    end
    object qryFranGrupoCOMISSAO_PERIODO: TStringField
      FieldName = 'COMISSAO_PERIODO'
      FixedChar = True
      Size = 5
    end
    object qryFranGrupoCLARO10: TIntegerField
      DisplayLabel = 'Claro10'
      FieldName = 'CLARO10'
    end
    object qryFranGrupoCLARO15: TIntegerField
      DisplayLabel = 'Claro15'
      FieldName = 'CLARO15'
    end
    object qryFranGrupoCLARO20: TIntegerField
      DisplayLabel = 'Claro20'
      FieldName = 'CLARO20'
    end
    object qryFranGrupoCLARO30: TIntegerField
      DisplayLabel = 'Claro30'
      FieldName = 'CLARO30'
    end
    object qryFranGrupoCLARO50: TIntegerField
      DisplayLabel = 'Claro50'
      FieldName = 'CLARO50'
    end
    object qryFranGrupoCLARO: TIntegerField
      DisplayLabel = 'Claro'
      FieldName = 'CLARO'
    end
    object qryFranGrupoOI05: TIntegerField
      FieldName = 'OI05'
    end
    object qryFranGrupoOI10: TIntegerField
      FieldName = 'OI10'
    end
    object qryFranGrupoOI15: TIntegerField
      FieldName = 'OI15'
    end
    object qryFranGrupoOI20: TIntegerField
      FieldName = 'OI20'
    end
    object qryFranGrupoOI25: TIntegerField
      FieldName = 'OI25'
    end
    object qryFranGrupoOI50: TIntegerField
      FieldName = 'OI50'
    end
    object qryFranGrupoOI: TIntegerField
      DisplayLabel = 'Oi'
      FieldName = 'OI'
    end
    object qryFranGrupoTIM15: TIntegerField
      FieldName = 'TIM15'
    end
    object qryFranGrupoTIM20: TIntegerField
      FieldName = 'TIM20'
    end
    object qryFranGrupoTIM25: TIntegerField
      FieldName = 'TIM25'
    end
    object qryFranGrupoTIM35: TIntegerField
      FieldName = 'TIM35'
    end
    object qryFranGrupoTIM50: TIntegerField
      FieldName = 'TIM50'
    end
    object qryFranGrupoTIM100: TIntegerField
      FieldName = 'TIM100'
    end
    object qryFranGrupoTIM: TIntegerField
      FieldName = 'TIM'
    end
    object qryFranGrupoEMBLDR10: TIntegerField
      DisplayLabel = 'LDR10'
      FieldName = 'EMBLDR10'
    end
    object qryFranGrupoEMBLDR20: TIntegerField
      DisplayLabel = 'LDR20'
      FieldName = 'EMBLDR20'
    end
    object qryFranGrupoEMBLDR15: TIntegerField
      DisplayLabel = 'LDR15'
      FieldName = 'EMBLDR15'
    end
    object qryFranGrupoEMBLDR30: TIntegerField
      DisplayLabel = 'LDR30'
      FieldName = 'EMBLDR30'
    end
    object qryFranGrupoEMBLDR45: TIntegerField
      DisplayLabel = 'LDR45'
      FieldName = 'EMBLDR45'
    end
    object qryFranGrupoEMBLDR90: TIntegerField
      DisplayLabel = 'LDR90'
      FieldName = 'EMBLDR90'
    end
    object qryFranGrupoEMBLDR: TIntegerField
      DisplayLabel = 'LDR'
      FieldName = 'EMBLDR'
    end
    object qryFranGrupoEMBLIVRE07: TIntegerField
      DisplayLabel = 'Livre07'
      FieldName = 'EMBLIVRE07'
    end
    object qryFranGrupoEMBLIVRE15: TIntegerField
      DisplayLabel = 'Livre15'
      FieldName = 'EMBLIVRE15'
    end
    object qryFranGrupoEMBLIVRE21: TIntegerField
      DisplayLabel = 'Livre21'
      FieldName = 'EMBLIVRE21'
    end
    object qryFranGrupoEMBLIVRE50: TIntegerField
      DisplayLabel = 'Livre50'
      FieldName = 'EMBLIVRE50'
    end
    object qryFranGrupoEMBLIVRE55: TIntegerField
      DisplayLabel = 'Livre55'
      FieldName = 'EMBLIVRE55'
    end
    object qryFranGrupoEMBLIVRE70: TIntegerField
      DisplayLabel = 'Livre70'
      FieldName = 'EMBLIVRE70'
    end
    object qryFranGrupoEMBLIVRE75: TIntegerField
      DisplayLabel = 'Livre75'
      FieldName = 'EMBLIVRE75'
    end
    object qryFranGrupoEMBLIVRE90: TIntegerField
      DisplayLabel = 'Livre90'
      FieldName = 'EMBLIVRE90'
    end
    object qryFranGrupoEMBLIVRE: TIntegerField
      DisplayLabel = 'Livre'
      FieldName = 'EMBLIVRE'
    end
    object qryFranGrupoVALEGAS: TBCDField
      DisplayLabel = 'ValeG'#225's'
      FieldName = 'VALEGAS'
      Precision = 19
    end
    object qryFranGrupoGUIAS: TIntegerField
      DisplayLabel = 'Guias'
      FieldName = 'GUIAS'
    end
    object qryFranGrupoMEDIA: TBCDField
      DisplayLabel = 'M'#233'dia'
      FieldName = 'MEDIA'
      Precision = 19
      Size = 19
    end
  end
  object dsFranGrupo: TDataSource
    DataSet = qryFranGrupo
    Left = 376
    Top = 224
  end
  object qryPostos: TADOQuery
    Connection = FormPrincipal.cnRegente
    CursorType = ctStatic
    Parameters = <>
    SQL.Strings = (
      'SELECT DISTINCT CODIGO,NOME_FANTASIA FROM V_FRANQUIA')
    Left = 320
    Top = 256
    object qryPostosCODIGO: TIntegerField
      FieldName = 'CODIGO'
    end
    object qryPostosNOME_FANTASIA: TStringField
      FieldName = 'NOME_FANTASIA'
      Size = 50
    end
  end
  object qryAjusteGrupo: TADOQuery
    Connection = FormPrincipal.cnRegente
    CursorType = ctStatic
    AfterInsert = qryAjusteGrupoAfterInsert
    DataSource = dsDados
    Parameters = <
      item
        Name = 'GRUPO_CODIGO'
        Attributes = [paSigned]
        DataType = ftInteger
        Precision = 10
        Size = 4
        Value = Null
      end
      item
        Name = 'COMISSAO_PERIODO'
        DataType = ftString
        NumericScale = 255
        Precision = 255
        Size = 5
        Value = Null
      end>
    SQL.Strings = (
      'SELECT * FROM AJUSTECOMISSAO'
      'WHERE (GRUPO_CODIGO=:GRUPO_CODIGO)'
      'AND (COMISSAO_PERIODO=:COMISSAO_PERIODO)')
    Left = 376
    Top = 256
    object qryAjusteGrupoGRUPO_CODIGO: TIntegerField
      FieldName = 'GRUPO_CODIGO'
    end
    object qryAjusteGrupoCOMISSAO_PERIODO: TStringField
      FieldName = 'COMISSAO_PERIODO'
      FixedChar = True
      Size = 5
    end
    object qryAjusteGrupoAJUSTEGRUPO_DESCRICAO: TStringField
      DisplayLabel = 'Descri'#231#227'o'
      FieldName = 'AJUSTEGRUPO_DESCRICAO'
      Size = 30
    end
    object qryAjusteGrupoAJUSTECOMISSAO_VALOR: TBCDField
      DisplayLabel = 'Valor'
      FieldName = 'AJUSTECOMISSAO_VALOR'
      Precision = 19
    end
  end
  object dsAjusteGrupo: TDataSource
    DataSet = qryAjusteGrupo
    Left = 376
    Top = 272
  end
  object qryBanco: TADOQuery
    Connection = FormPrincipal.cnRegente
    CursorType = ctStatic
    Parameters = <>
    SQL.Strings = (
      'SELECT CODIGO, NOME FROM BANCOS')
    Left = 320
    Top = 288
  end
  object dsBanco: TDataSource
    DataSet = qryBanco
    Left = 320
    Top = 304
  end
  object qryGrupos: TADOQuery
    Connection = FormPrincipal.cnRegente
    CursorType = ctStatic
    Parameters = <>
    SQL.Strings = (
      'SELECT DISTINCT GRUPO_CODIGO,'
      'GRUPO_DESCRICAO FROM GRUPO')
    Left = 320
    Top = 336
    object qryGruposGRUPO_CODIGO: TIntegerField
      FieldName = 'GRUPO_CODIGO'
    end
    object qryGruposGRUPO_DESCRICAO: TStringField
      FieldName = 'GRUPO_DESCRICAO'
      Size = 50
    end
  end
end
